Import Page Properties
Use this function to import Page Properties, such as Page Descriptions, from an excel file during the file import process. Refer to below Excel File Format for specific file details.
Accessed from:
| Setting | Description |
|---|---|
| Import File | Path and excel file name containing Page Properties. Selecting this field opens a dialog which allows you to browse and select desired file. |
| Sheet Name | Pull-down list of available sheets in the selected import file. Select the sheet that contains the data to import. |
| Start Row | First-row number containing desired data to import. |
| OK | Validates Title Block, Page Format, Mode values and Imports data overriding existing property values in Import Drawings Dialog. When an invalid value is found, a Warning message with specific details opens and default properties from Project Options > Pages Setting > Page Layout Tab are used. |
| Cancel | Closes dialog and returns to Import Drawings Dialog. |
Excel File Format Details
Supported Microsoft Excel formats:
.xlsx
.xls
Field Mapping Definitions
| Excel File | OpenUtilities Substation Property |
|---|---|
| Column A | Required. .DGN file name. This is used during the import process to create a relationship between records in Import Drawings Dialog and the excel file. |
| Column B | Page Name |
| Column C | Drawing Set |
| Column D | Default Page Installation |
| Column E | Default Page Location |
| Column F | Title Block |
| Column G | Page Format |
| Column H | Mode |
| Column I | Scale |
| Column J | Page Macro |
| Column K | Page.Description_001. Page.Description_001 refers to the internal name for the top most description in Project Options > Pages Settings > Page Descriptions Tab. |
| Column L | Page.Description_002 |
| Column M and beyond | Previous column Page.Description_### + 1 |